# coding: utf-8

import pandas as pd

wutandianhao='物探点号'
lianjiedianhao='连接点号'

def getPTable():
    #打开excel文件
    df =pd.read_excel("HS-汕尾项目总库成果表 - v1.xlsx")
    print(df)
    print(df.drop_duplicates([wutandianhao]))
    df.drop_duplicates([wutandianhao]).to_excel("HS-汕尾项目总库成果表 - v1-导出1.xlsx")
    # for row in df.itertuples():
        # print(row)
        # print(getattr(row, wutandianhao), getattr(row, lianjiedianhao)) # 输出每一行


if __name__ == '__main__':
    getPTable()